SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 459470 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 459470 [ RunTime:0.002034s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (973582,521973,958145,746550,119953,127223,34648,1041714,348202,739719,210715,1040229,403759,379000,25011,919238,824830,632021,101321,220533,528009,977055,876663,519468,813084,903223,20002,916122,1019533,330480,758933,972379,511741,420156,933484,650264,302767,627464,490617,647440,702640,538074,805424,936061,407410,469486,310605,315123,530997,101147,992047,498924,851898,599299,57371,244014,636366,684765,741151,703191) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001778s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 459470 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 459470 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]