SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001333s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 532798 LIMIT 1 [ RunTime:0.001113s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 532798 [ RunTime:0.003963s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (949485,204100,506410,588937,928816,1032862,515034,325017,706949,304716,117985,695060,316800,901009,769373,794881,806424,696520,322869,559077,1037434,943565,61088,4739,353381,196616,889893,652790,53160,938554,557929,718008,296645,1017002,543217,4704,220071,957263,1027626,53042,297550,789683,401122,971899,161695,350032,238023,669914,621129,665686,446271,152763,146503,735772,706456,404230,100952,662688,394616,968128) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001048s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 532798 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000536s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 532798 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]