SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545281 LIMIT 1 [ RunTime:0.000478s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545281 [ RunTime:0.001531s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (534437,811350,520685,314773,801845,823600,656983,967021,500286,839398,783398,467718,368370,674819,322039,280818,499726,231885,237710,454136,939510,240065,802157,473958,155018,785871,997844,495916,451984,307374,1038307,623953,271736,227284,409564,1010830,66265,680111,343624,638684,387321,547251,712045,990488,52180,703589,430823,315956,102353,234646,869772,700752,520765,237849,326372,387405,525419,949755,822974,69144) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001006s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545281 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545281 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]