SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105161 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105161 [ RunTime:0.001683s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1032214,666408,692436,512944,785431,626801,184388,350150,621358,1040680,590936,117998,905953,491450,446842,443283,59907,574786,148160,358840,866479,798641,49480,185228,524679,930774,347790,13851,961331,113647,986141,906899,926010,596195,936115,893553,81252,986070,416401,870169,431408,579448,587802,761845,539300,255993,961478,697619,253564,308540,586210,909009,832308,848615,46280,294339,134943,67221,917918,267436) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105161 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105161 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000408s ]