SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 533570 LIMIT 1 [ RunTime:0.001806s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 533570 [ RunTime:0.003733s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (879329,463886,975518,477847,195626,431801,538514,217112,412976,779091,830519,503179,141773,588053,64111,974711,110284,692990,468830,581074,393595,952965,54069,141086,137974,412017,306931,156078,885745,925400,251075,368598,462193,134961,572233,664157,128612,808500,208019,42742,239008,727124,645030,58954,513387,962396,57365,358563,213109,977763,79814,616374,415750,729192,727372,176030,611279,601939,419360,95410) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001727s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 533570 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000560s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 533570 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]