SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 375743 LIMIT 1 [ RunTime:0.000430s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 375743 [ RunTime:0.001582s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (404200,139527,1006690,1034293,183331,37321,891664,478037,246899,811963,134537,521738,861177,468632,582239,203438,234500,98567,299671,881374,518615,50438,34903,841611,376518,180115,543899,926934,582277,678002,454327,698084,112921,24557,67873,1003865,504735,60473,69654,1045831,457978,8225,328013,236525,250781,901607,549060,309599,369446,419392,707012,194094,847147,329782,676280,1031384,508544,385596,305831,601739) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001274s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 375743 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 375743 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]