SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 583800 LIMIT 1 [ RunTime:0.001875s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 583800 [ RunTime:0.001949s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (506693,844963,890851,164607,600790,992251,404279,737626,843898,404164,428929,984358,531608,522058,435750,40463,572628,873804,12768,135050,332487,928502,572782,573902,834415,798509,95878,656004,809929,226046,587559,313157,224579,2255,941532,278661,847432,713138,230963,713022,699207,216253,981160,363830,555030,51445,943120,500778,111221,94669,348717,439772,114586,394817,236541,169966,874747,143584,805180,869137) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001989s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 583800 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 583800 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000659s ]