SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001385s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 395364 LIMIT 1 [ RunTime:0.001560s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 395364 [ RunTime:0.001949s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (470949,276475,349136,324725,175242,407271,46448,254205,438671,477478,116510,560606,149198,288219,555114,273463,1004161,611997,542165,45621,1040895,622469,210657,840759,694685,102308,178062,620819,260889,781271,57213,665618,733690,562702,632820,864614,531932,55144,612981,326236,967795,887293,455437,266936,126414,718940,684030,88319,977760,902969,187606,517678,470161,847106,706710,28267,370839,813442,10184,835029) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 395364 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 395364 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]