SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001307s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 57528 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 57528 [ RunTime:0.002138s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (490880,48050,825086,656488,692019,757234,781374,5559,781613,142274,317535,668943,568845,516070,633642,72269,112734,485162,470135,804106,168953,940822,645620,803494,990423,145418,137345,860764,76324,686398,737885,316529,136126,837013,238154,644848,522379,878468,230231,294927,958368,391549,572156,877019,628696,423007,344911,906799,272115,847367,453116,579018,840583,127120,824950,82966,680507,299302,50984,666532) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 57528 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 57528 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]