SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001438s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1027790 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1027790 [ RunTime:0.002635s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (239118,328392,490695,1036896,437991,854925,692389,345589,1004860,936086,443685,147698,1033925,327565,868554,98760,1040557,447770,997190,334167,1031559,732995,114624,494527,308606,905938,649752,881579,901680,982410,640070,532944,270032,999094,885148,411822,307592,686241,545261,38383,945797,452877,161479,659817,231178,836199,115980,806049,481073,21921,528696,934450,338007,101251,733064,99342,163732,140956,675119,712951) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001110s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1027790 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1027790 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000444s ]