SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 199710 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 199710 [ RunTime:0.001627s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (933324,411220,891890,41976,666176,229546,214240,1194,195627,820668,759729,562003,420526,928812,987985,803325,940766,442365,154583,826846,312250,838416,1046156,785694,565963,995552,851491,505327,112395,47728,884181,428099,77790,809412,813272,43307,845466,914173,726330,295103,1000188,97352,897718,116869,1041219,656618,584902,648466,219550,488844,488875,968500,588648,371706,25051,218865,258715,759645,777940,424369) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001817s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 199710 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 199710 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000618s ]