SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004458s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1013290 LIMIT 1 [ RunTime:0.003062s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1013290 [ RunTime:0.006427s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (153138,712866,401643,885950,137984,991562,732383,384895,219469,281049,821210,465851,962039,384020,701983,86941,318480,462974,704649,615307,486850,328273,21727,584832,178841,834860,561101,572152,763540,336042,18930,85191,150694,862938,466977,694019,185705,294415,987419,494565,64828,764326,575920,328342,914010,24488,1002658,1021708,567612,1015383,708709,284153,661190,417313,1006690,639566,831536,254229,371117,259303) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001478s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1013290 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000747s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1013290 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000724s ]