SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046790 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046790 [ RunTime:0.001751s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (510567,909482,950012,169295,91614,27972,498638,70500,351014,890078,911197,657704,353065,62280,711779,640671,358749,677897,690351,658313,849305,862659,34271,24965,662947,828962,601331,735788,311512,520051,840930,476193,711590,679212,230761,968877,525511,210323,587135,476392,853473,74975,101907,393612,297470,732353,192451,794624,271075,994264,908686,704170,523223,877580,1041824,646353,112387,719868,523297,180998) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001013s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046790 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046790 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001421s ]