SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001865s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 975918 LIMIT 1 [ RunTime:0.000911s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 975918 [ RunTime:0.002148s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (697829,40886,341981,684632,992899,215887,81652,133414,482470,394505,403570,946749,786567,41682,545548,122265,839155,392257,789384,824598,690085,13771,265732,87994,865639,103826,96187,691788,141294,174292,14855,459023,278973,45818,754361,376524,654136,762423,960841,191737,377147,146499,717639,826554,17829,986529,420407,347731,918496,208309,63428,661316,740540,876788,707895,1044182,258717,957392,697446,275532) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 975918 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 975918 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000470s ]