SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002647s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 290364 LIMIT 1 [ RunTime:0.000818s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 290364 [ RunTime:0.002617s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (39154,417892,523310,889450,902817,885467,747108,167233,259632,251143,245713,284927,718679,428721,780013,876108,137524,720876,1003330,418127,784539,739163,994398,26805,136759,64862,435856,912399,678758,588277,953547,573427,853788,650647,727497,125385,617087,398809,287831,487074,761300,813228,892945,544068,655965,500125,157334,665173,604674,1972,383925,94985,926922,232635,618561,780469,803897,141913,451058,36899) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 290364 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 290364 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003151s ]