SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002090s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102861 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102861 [ RunTime:0.001957s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1005781,327580,515783,161739,1027538,632859,253854,500249,702709,1007689,662268,1010500,816648,107350,672127,477554,37251,848948,631116,97512,1000250,499277,603812,154999,341665,49392,276134,913038,737016,685584,84856,88616,707067,585783,972885,443772,33864,836518,814535,110398,889983,335052,65708,927717,87610,495423,1027597,312566,495799,268904,489936,643728,372339,21467,25309,26801,990385,141280,242153,81102) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102861 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102861 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000646s ]