SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001459s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 749800 LIMIT 1 [ RunTime:0.000808s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 749800 [ RunTime:0.001834s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (502243,671916,543214,1012451,641874,400638,450261,148259,249068,282729,633060,170913,621721,972742,178424,320815,645600,302376,420803,79905,815736,550700,957884,916829,590129,53799,252723,384282,244866,312840,27819,788866,300518,662566,952011,361095,440438,529970,584308,751250,53739,916450,136874,822950,68303,992294,42147,372851,500033,518080,417948,955683,213822,390763,932212,329545,533258,482712,859623,23209) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 749800 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 749800 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000503s ]