SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 467328 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 467328 [ RunTime:0.002725s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (476126,210366,223001,660253,755345,330933,853252,498960,16996,159674,219520,118828,579664,904237,197062,96410,1040600,942634,275107,984871,343464,422327,502778,336908,223737,554555,720113,4070,132864,1038389,657760,918466,1037110,214249,489133,682569,746322,747633,272595,525272,235849,756262,893870,876063,250325,181533,968499,424305,459196,866177,125835,48069,587728,829303,1004655,741572,569285,866068,299193,781394) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000957s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 467328 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 467328 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]