SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 297038 LIMIT 1 [ RunTime:0.000529s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 297038 [ RunTime:0.001749s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (659681,514043,860842,397397,1006156,380370,317080,131720,1013717,283248,975090,769691,513966,313837,71199,46950,313077,569926,684033,938047,904142,64349,948983,64547,239095,808814,641230,1042694,3586,584414,642874,1027756,29947,413992,685399,152531,727505,1026580,276406,162628,433963,253968,972184,302017,180765,1033422,194563,290012,484924,164022,262143,892135,976556,231954,717859,45393,701415,601514,366260,104927) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001094s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 297038 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 297038 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000630s ]