SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412295 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412295 [ RunTime:0.001811s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (553261,820816,570947,425541,103065,959655,937806,771894,995891,423067,450944,710539,601431,778644,630133,499519,1016934,228766,172746,910327,128987,407424,299684,389742,346406,268321,279231,873038,383953,728450,479665,142048,909635,688584,595773,964685,539105,93708,499243,14972,55586,464708,134558,612235,162929,55252,4757,413090,834172,945358,333366,764892,194683,46658,421875,303454,610796,774608,906887,447674) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412295 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412295 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000643s ]