SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001056s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 455590 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 455590 [ RunTime:0.002270s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (374836,309243,519278,307852,210000,557209,512183,92654,125101,905877,254739,918734,201950,150435,287676,157066,131418,190156,314192,633633,957015,683044,463941,765205,982842,338007,576237,281527,417388,222569,481158,145336,480107,177314,602463,140864,477317,753510,260604,311097,98560,493968,914457,377708,960095,579592,713914,73088,414410,838493,939449,462980,941416,41770,520198,259621,139645,593768,834322,118357) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001626s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 455590 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 455590 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]