SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002545s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 515028 LIMIT 1 [ RunTime:0.000588s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 515028 [ RunTime:0.002385s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (420822,138018,83106,157943,848218,617832,650905,309529,343320,1015104,438501,698355,156159,929516,357453,42711,800179,450891,979339,145999,837429,537327,949963,853614,862565,516033,247640,564093,414479,772651,551294,966833,420094,56350,925652,133599,367906,448706,966501,920440,196889,49532,305694,840090,881747,11458,81556,161307,912220,832909,586587,924901,329925,380488,1028560,479436,1030742,739251,422790,816652) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 515028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000495s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 515028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000744s ]