SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001321s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545341 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545341 [ RunTime:0.003350s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (471585,657374,997137,726839,245102,26423,83116,138492,18093,661793,396072,390078,512573,109834,33668,624338,788484,1037714,831133,115037,649004,247339,724362,140612,85001,198821,812536,660310,957553,361248,366840,2915,785633,202523,5370,516740,533147,349731,889874,969424,249508,161634,196317,711128,779492,351230,350404,196562,776487,53732,761330,1040328,608929,154325,229638,297860,158582,277534,470837,471740) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545341 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000546s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545341 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]