SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001296s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 294517 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 294517 [ RunTime:0.001821s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (473714,992801,871269,422574,976514,321512,875675,352174,523783,213493,836866,928073,1032513,259098,811811,408958,530740,781100,448764,911533,751095,1040582,313953,169440,32465,86300,765810,411639,883926,983840,893064,850850,752463,511572,878912,167637,968253,866728,581151,95371,610085,126607,32958,1010618,260034,941083,364768,479589,859223,18608,332182,111402,974823,583649,926065,851711,759789,723250,384121,831255) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 294517 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 294517 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]