SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801244 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801244 [ RunTime:0.004712s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (435773,108862,572718,944901,700464,759818,457114,52950,574259,517804,100544,601285,50211,145443,582120,316508,394653,239262,505702,1037584,630429,34840,1012500,854203,599298,255202,42927,661830,619324,884296,780256,579728,930977,366704,186111,177468,697451,122806,329181,1048500,219947,602194,380559,255044,925647,574918,707819,208746,293435,614536,636476,273012,1024776,735594,754731,264875,598076,668796,496831,250400) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001566s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801244 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000714s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801244 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003574s ]