SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 803212 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 803212 [ RunTime:0.001901s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (159550,201915,741795,993823,398595,925299,172651,404170,94030,798252,668457,175338,856544,14343,986215,878463,983497,623029,28775,66122,463976,107373,1028101,846657,845384,562401,114011,433862,428284,504986,286636,11210,864206,369677,949357,658438,340254,472628,196459,191870,764601,587963,70561,922758,843742,179770,410678,253810,288871,520505,261757,872661,1015637,566294,491407,124799,329123,648487,473294,316909) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001023s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 803212 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 803212 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000934s ]