SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415367 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415367 [ RunTime:0.001576s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (286974,433071,157074,820657,153808,355817,126548,500457,512423,813813,642773,501804,709282,659643,220484,1036468,921963,144902,837391,678758,545900,671519,845923,120178,817972,618363,337994,657039,1039424,927281,299771,385460,259417,363460,758896,598158,627753,355303,566846,381562,759754,264650,745550,29656,459097,85700,264069,116438,269566,371373,177606,984487,39852,689139,951178,489203,120723,366335,890272,984582) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415367 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415367 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]