SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 536306 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 536306 [ RunTime:0.001960s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (710298,680895,103581,149265,1043356,393612,544260,670165,652719,907527,236630,286323,851683,501977,773545,778834,713314,982806,40608,1015785,528244,480495,493793,599610,39098,840197,337894,37221,232046,1041523,155599,246821,175397,938066,641428,544877,544103,593326,375005,33490,45309,759109,865418,12148,62452,824032,233147,186321,769230,254699,347239,850143,48704,667875,100344,502182,932892,838023,243478,814063) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 536306 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 536306 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]