SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001584s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 452718 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 452718 [ RunTime:0.001638s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (222397,547910,991081,20303,662149,671782,860852,919180,529422,25139,706427,1025288,660369,788466,276894,279836,433983,48265,77041,21069,980330,559380,353175,939850,394442,422023,858047,590251,887974,225929,647774,991236,481065,56337,915059,312775,816581,555581,293571,472697,306363,607191,775931,57743,67698,184835,489178,922572,1037903,1025661,231665,746348,430428,1040430,790660,763055,614671,422196,1048433,894876) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 452718 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000529s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 452718 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000704s ]