SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404893 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404893 [ RunTime:0.001718s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (510325,563273,691317,289208,848378,983506,585202,79732,495021,657521,702945,747026,599797,855821,276008,826426,69680,603092,656668,968925,748588,896134,1008009,138877,720237,436559,494104,896690,256675,53271,76706,749260,109840,902684,978741,308649,238615,357590,696314,497976,8033,1040700,104921,169208,978385,318277,53590,369870,453796,901205,884296,1021998,1043622,375038,605306,1048582,996847,78944,192303,686421) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404893 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404893 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000472s ]