SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40718 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40718 [ RunTime:0.001403s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (132311,197307,587001,41253,751830,845561,7986,158246,906641,804538,612421,318375,82127,177226,518544,195179,567292,858749,656906,764815,140558,398492,64879,308656,434446,658619,67639,149310,346350,584078,280961,368500,575563,971408,686244,672083,498952,951862,60625,480767,444599,757858,444783,259695,914625,601781,531437,372599,949022,618840,244254,739200,656488,326553,13375,770371,492113,335381,589549,631637) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000965s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40718 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40718 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000479s ]