SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200967 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200967 [ RunTime:0.001598s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (967384,365102,614725,886690,942537,1010320,948862,100414,15731,973265,471124,531144,755470,376685,218378,155354,820412,840622,377410,948606,413021,46503,183430,503808,809519,545772,500444,685455,14443,97565,396260,543441,752725,167746,213764,495364,46575,616833,164399,798946,732518,550110,180944,39028,181814,269231,531912,363932,878700,710156,208218,806451,961124,721828,315640,587306,804993,79766,486432,940883) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001732s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200967 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200967 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001104s ]