SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 811207 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 811207 [ RunTime:0.002415s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (852725,628769,199915,374816,709715,549276,880414,70013,218119,838235,609100,134732,203847,10921,945589,366308,1045770,1006003,425417,742976,2523,590823,962744,503435,912680,55679,694841,634668,651687,40414,90637,415208,807380,740244,753672,18341,760570,362050,1043255,771131,264879,508508,243728,589279,204771,485838,13521,621531,81177,454000,77645,113513,121138,207075,521541,650206,971090,282722,797255,363283) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001472s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 811207 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 811207 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002807s ]