SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 971341 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 971341 [ RunTime:0.003496s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (184387,523020,759274,510285,183698,888046,300331,755526,638328,510551,263968,126002,740758,553354,825733,946887,934272,403559,331828,792349,658807,57478,30852,345328,1010680,32007,148417,293321,125163,102330,165622,362676,507304,1040168,376370,770812,605298,657000,663278,467510,579240,748649,55941,1001602,591300,667105,1021903,122945,993221,904673,482159,477861,712517,478586,697379,696491,565294,1013892,245404,519765) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001318s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 971341 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000634s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 971341 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000723s ]