SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001316s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501391 LIMIT 1 [ RunTime:0.000500s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501391 [ RunTime:0.002383s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (552526,332230,424893,558067,420131,825095,158211,400413,406015,11928,247623,377778,1002901,992775,636914,684829,616540,257537,959955,302155,688341,45173,741990,908437,227689,985397,73962,919937,930323,80488,317162,301476,969115,486622,657066,333537,113338,47602,975776,691726,3425,130673,29116,921659,15522,907869,270857,981764,452327,1036391,229998,576365,1028692,157917,430174,1048384,676992,167666,975083,743939) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501391 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000970s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501391 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002278s ]