SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104810 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104810 [ RunTime:0.001706s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (126663,552484,1033175,241512,15529,610271,713939,367282,306977,654223,242203,699254,378790,265281,356333,749534,279650,14469,160050,846817,267790,130993,946304,266724,1047488,151694,361204,391982,6696,296477,379786,707187,119625,518881,391282,875562,485971,826633,584864,790571,898808,654836,919177,1015702,449381,699032,959695,212866,425841,126791,728460,51470,639364,1020299,955628,851438,10425,502929,177268,575744) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002019s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104810 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104810 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000658s ]