SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 374918 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 374918 [ RunTime:0.002010s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1014494,346281,813139,700525,838119,650457,312657,1020458,245209,4160,901688,984419,519053,445626,593171,243338,537160,732346,79065,781352,291766,430917,347162,84682,926512,548367,23540,76070,1024252,305815,882511,970331,124497,836992,101241,129707,190308,883467,606389,1038795,174143,319924,145431,7958,856687,1024684,8525,271380,355863,875352,653508,550483,220116,339084,341380,474185,497881,280731,765338,159527) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001022s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 374918 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 374918 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]