SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 991041 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 991041 [ RunTime:0.001886s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (62106,928381,708782,426572,771805,767316,171477,21730,976810,308003,168518,475862,404645,488130,674348,990189,410922,205519,390736,102812,155660,1034243,475793,140962,296169,340572,1007348,237429,376354,12640,444151,570853,682279,366415,413001,656565,387352,446784,864635,944745,910332,954340,985583,948504,49359,433127,925460,1036788,958078,743122,1029774,875355,403671,730625,592110,753469,605838,521133,761688,1044243) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.011888s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 991041 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000886s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 991041 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002421s ]