SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001285s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 218878 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 218878 [ RunTime:0.001826s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (185187,775666,749464,481798,1020317,327545,1007033,285101,917972,724074,855911,916489,835000,121749,439505,976388,314646,985112,379396,53730,66424,1018873,126056,300673,264349,569891,357874,769593,475532,823661,233031,714691,46886,1025864,277583,247700,458343,81010,583034,313827,895203,312872,302485,363282,508980,445726,414305,907442,969559,1044553,92090,671303,1001845,716179,909425,930345,457872,899252,509665,1002356) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001027s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 218878 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 218878 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]