SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 427149 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 427149 [ RunTime:0.001524s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (531222,801906,255862,942415,334512,142261,33369,404734,2977,502610,1038030,624920,805963,694483,951812,24064,216248,18748,483797,145309,299173,784933,929953,823486,212402,298106,744081,355742,32915,732197,216624,1033526,655628,862629,64909,998650,557152,776112,1014301,84498,651778,87728,812034,924890,384612,625288,206961,708728,1036172,587385,119098,454588,691583,833172,50246,619541,280918,289119,103564,187130) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000992s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 427149 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 427149 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000621s ]