SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103706 LIMIT 1 [ RunTime:0.000472s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103706 [ RunTime:0.001498s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (515804,291113,610304,725611,882317,200117,502255,1048770,623621,307373,508752,222035,14105,793585,319498,406357,509100,550209,127171,628966,862351,852487,88518,922961,495603,916649,196251,987835,995341,704215,476100,924120,845510,997598,547509,537878,935436,733058,877046,162433,635132,990957,315761,25204,357743,558106,281582,428078,537900,189771,272180,275525,155103,658942,419224,144640,308372,1032979,979503,657277) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103706 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103706 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001032s ]