SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001396s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508880 LIMIT 1 [ RunTime:0.000449s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508880 [ RunTime:0.001793s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (496818,274507,499119,464434,730112,20673,1032000,335807,17948,476165,105068,111999,12299,876423,351741,893205,222093,402932,794725,544240,18908,917247,922856,424225,35949,167680,473989,391899,416589,1030975,773551,925030,613189,785218,1020405,389042,325562,271972,10737,631644,340344,255726,151481,880589,410670,712937,439885,980395,532338,613437,11806,780439,902911,790153,94207,526311,203335,416305,310202,208936) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001028s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508880 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508880 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]