SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401953 LIMIT 1 [ RunTime:0.000448s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401953 [ RunTime:0.001852s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1038013,189522,16403,243880,158813,975011,937010,715344,246291,952342,1013680,909899,890098,417588,536135,105361,976083,978867,625509,562438,888349,153424,990107,581608,438876,50668,213719,131132,27576,683746,908052,114329,719299,879131,318734,899261,521086,594296,784818,986596,552536,198748,796281,1045129,262483,166055,345290,447032,723998,991858,542448,875569,860584,427032,695520,440293,543458,487123,788425,976923) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401953 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401953 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]