SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 532011 LIMIT 1 [ RunTime:0.000427s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 532011 [ RunTime:0.001895s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (730837,621440,745790,232068,1024762,338124,689174,690566,539361,215618,1043774,582675,460605,482166,733031,889573,791466,611972,642289,911479,964236,904753,498644,993209,169480,1017719,886765,310463,687250,320782,612340,741864,249160,402303,125221,339354,275676,356579,529371,244479,249728,478981,523093,580536,742539,617385,158416,923188,42820,520919,408984,369292,902978,333708,1048143,588663,976859,433406,11223,5951) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 532011 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 532011 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000510s ]