SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001640s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 139220 LIMIT 1 [ RunTime:0.000437s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 139220 [ RunTime:0.001955s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (499096,434490,646091,480495,601466,323148,30095,318784,929674,753019,839005,1027829,685838,677830,122632,821119,57285,533388,768664,609627,224556,698556,815745,796266,839037,571994,444217,767612,209859,612844,729923,575088,125570,164059,90637,837490,246022,883252,380295,984929,436078,670491,496077,859538,827333,835201,73773,929859,267529,196631,730599,383469,518262,638471,658584,739859,1024740,554993,95000,690540) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 139220 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000645s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 139220 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]