SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002271s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1038887 LIMIT 1 [ RunTime:0.000437s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1038887 [ RunTime:0.003899s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (87819,704490,691714,942259,975986,720973,963698,530634,866339,864135,199695,354126,322361,260237,624131,1010582,817527,867686,16020,665038,939102,93600,650377,805651,796892,797843,51971,347652,604831,235327,445761,238069,435573,47551,1024132,981084,73762,996217,881338,833627,680727,1000700,810393,168490,388360,132848,993019,898737,832003,444361,387754,1007257,970241,635714,588176,640271,927296,22397,743780,920832) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001320s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1038887 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1038887 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000569s ]