SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001391s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501980 LIMIT 1 [ RunTime:0.000418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501980 [ RunTime:0.002042s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (612520,379195,588879,351039,285059,732624,478081,240444,488022,66756,960474,105964,894411,490862,751669,267689,519962,657662,682790,260809,753874,515133,817901,1025478,802473,934773,631077,473188,706150,788337,501442,488960,496483,159048,329364,812945,103032,25110,342409,184953,649809,696135,463426,83024,105804,113957,56396,822064,157111,134614,376918,287964,761199,628804,459597,923430,818237,63298,722975,973118) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000969s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501980 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501980 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002858s ]