SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001702s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 516620 LIMIT 1 [ RunTime:0.000730s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 516620 [ RunTime:0.003143s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (340914,961332,757699,236688,666701,850982,893711,1007797,361721,708610,838543,49988,332354,1025396,534225,142504,483968,903764,617505,292305,517570,36964,446431,873114,625208,25433,12338,482858,1034544,173613,390315,253285,331208,328664,650183,766537,139735,841513,502343,156507,108172,112883,723512,699476,32175,606128,300679,963465,513632,278808,676627,199732,537463,418473,104704,270369,630185,1022919,752687,1029848) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003774s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 516620 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 516620 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001901s ]