SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 840991 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 840991 [ RunTime:0.001917s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (442429,446878,689700,712157,262352,389440,304816,331981,289834,590484,181802,428528,388421,151353,840111,22905,915966,620810,408500,934717,751847,476648,889592,334769,1044069,53125,515232,41217,1037571,648543,745017,387576,523495,71272,523148,606353,49725,946662,755466,640546,667555,50067,868950,890573,28421,620619,335415,658245,817035,884584,697494,196060,953996,246619,996492,339765,726143,169064,922292,634793) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 840991 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000772s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 840991 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000437s ]