SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541071 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541071 [ RunTime:0.001663s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1030340,485339,854245,378243,887373,91731,587850,760446,966369,120212,785485,119805,749124,208483,869266,502530,986424,442186,980703,47081,992994,468595,167901,1009231,906928,625019,313271,52984,270681,484078,183601,794862,6276,92582,939995,180915,834684,831784,719538,229799,35588,56328,591257,1035956,1008342,848839,185657,355427,1030506,616747,198390,157899,847751,64159,807360,1018772,133394,142365,1025972,430234) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000989s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541071 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541071 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000469s ]