SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001287s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540570 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540570 [ RunTime:0.001523s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (667355,131127,437064,710908,364157,396012,30884,153427,538919,169254,763866,591379,731394,955079,229774,375917,460718,1045994,945126,473904,856278,916292,457176,401991,366932,421698,116662,856249,930489,326014,626592,581819,36705,826177,1006120,303572,863777,859912,507077,118932,626966,75029,804930,895637,27453,561127,504004,727379,93626,830837,1020428,268936,63128,507527,70201,443592,43998,157786,156824,373268) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001026s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540570 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540570 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000525s ]