SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 425699 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 425699 [ RunTime:0.001876s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (123918,548599,160800,216072,124899,308510,666547,206171,328630,1040466,660399,233282,954934,441006,635640,841843,634959,932591,54970,151168,779434,614618,259671,315530,783614,195036,718644,972754,454900,864607,46565,281288,460989,373338,523123,1019958,809860,115324,296207,510257,227652,244147,658164,557832,555258,752629,106809,552005,422196,232979,685031,976153,808866,261780,964373,944796,42022,1040047,441071,157329) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000994s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 425699 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 425699 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]