SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 586821 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 586821 [ RunTime:0.002012s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (892905,1033701,998188,518083,597874,690300,838818,357490,591546,919904,12223,911993,607276,166564,944717,281015,838134,869027,265191,218745,753033,213612,468290,1036717,296066,195225,313282,781699,831135,832842,66897,857884,133154,810561,982922,368980,156656,981689,1028365,691295,212709,306300,418724,641873,985989,765744,50105,858313,639121,11642,514024,144503,906824,42645,803756,923853,139050,963925,819187,354108) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001055s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 586821 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 586821 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000569s ]