SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 47320 LIMIT 1 [ RunTime:0.000451s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 47320 [ RunTime:0.001697s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (332941,395523,719475,138984,174405,645946,152051,264670,75708,815915,265511,220678,174370,1039214,943608,487298,774044,220666,463469,512957,645831,812720,887310,289311,844269,351914,530628,826510,349697,264104,820773,937981,702282,858080,757256,314485,838513,201700,64921,945258,909350,797212,739536,1012443,411965,595659,912256,993882,97117,418909,644100,45136,465891,298615,32757,991491,375377,1045875,589296,336676) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001020s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 47320 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000478s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 47320 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]