SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 345098 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 345098 [ RunTime:0.002008s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1047864,57762,616470,365560,656916,1030277,128685,888171,30203,508450,893262,950381,366670,240882,619926,234274,946692,1018238,867889,996774,384277,794907,433104,294968,947375,1046606,441544,558517,965463,371689,6609,338419,976877,274564,723245,296170,629578,110354,725994,442825,3564,11035,888629,320630,816075,531752,599890,477033,406678,36857,394879,274320,608804,30543,67305,1011399,461268,791751,922845,490014) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 345098 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 345098 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000456s ]