SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 494188 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 494188 [ RunTime:0.001675s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1036069,220375,430719,32188,278603,133836,323860,416093,923258,134341,315637,199191,992202,433476,891428,763490,120449,866989,197052,645308,626721,885252,5530,592165,150431,890665,52090,146846,261628,342930,593280,977147,372680,712957,387801,380006,434398,205194,801090,282605,499866,664857,707220,169802,696516,233424,943106,999566,909066,110522,741288,817382,893852,638796,872629,480598,116730,951882,747924,820410) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 494188 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000635s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 494188 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000636s ]