SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012419 LIMIT 1 [ RunTime:0.000455s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012419 [ RunTime:0.001768s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (738164,767470,609069,97762,716058,648980,453701,687579,768305,327527,253228,136651,839417,33247,72019,597758,536757,62634,625837,655414,1023628,902743,1002527,375802,308172,281709,341096,985364,969186,244123,331451,86438,544082,20363,470639,803890,553062,144079,1018337,371989,561980,973970,712792,649177,247412,748068,775239,706205,116082,240650,531786,755104,674829,140552,373839,935864,114414,866107,456202,838996) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002180s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012419 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000515s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012419 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000663s ]