SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 442894 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 442894 [ RunTime:0.001830s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (675137,710094,393611,641213,788066,281297,846268,768834,260103,341945,78461,808623,911378,850934,143020,140168,986728,453156,89847,259976,853832,20785,6909,709111,676580,745657,1014806,117939,26194,933980,213734,804293,856654,794632,787461,739786,662000,530854,568918,262008,85300,287853,286979,606785,831286,580044,232210,388360,231618,444626,943851,987474,289099,420431,90301,387785,782477,89986,940161,462370) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 442894 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000543s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 442894 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000791s ]