SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105052 LIMIT 1 [ RunTime:0.001614s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105052 [ RunTime:0.002532s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (852443,494083,304621,319280,460145,145091,305008,632333,650009,1007195,191370,259513,160505,836007,20452,32641,6515,742088,837212,360168,54162,156863,207590,461009,798748,49620,58415,321737,648804,457485,114446,458914,945346,119128,575924,153304,2,270192,633324,1010054,48831,973787,106501,371699,88294,858140,60087,98671,655784,390429,757136,830371,425595,454201,124120,876303,64863,5538,657692,985741) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000949s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105052 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105052 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]