SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001328s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 601441 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 601441 [ RunTime:0.001777s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (440017,251434,894370,134669,666255,920085,45318,59204,580505,386330,662679,319075,1025227,78190,923171,712460,1043123,795346,740242,802955,477988,505030,51089,329214,1046943,170263,586175,983693,1041267,172918,483188,78846,334356,471763,77693,15830,299524,65814,278090,400647,53706,702375,446642,879966,833092,460385,503873,521370,199276,368333,940240,274371,799665,559307,139212,843497,648122,510715,16263,413453) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004963s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 601441 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000497s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 601441 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000417s ]