SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 381178 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 381178 [ RunTime:0.002547s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (469090,176667,421863,262911,582639,378340,465446,421526,485806,4886,870305,481328,882991,222755,769576,217826,629471,349004,672104,87224,99984,49962,804246,346513,374265,797456,139005,120080,114844,854170,497257,477402,279043,464033,1002757,166751,881856,654348,218195,239209,1014073,825664,747721,802583,674810,813022,527285,514208,147847,292333,49678,546763,911023,118581,99561,442987,1012264,883822,308843,238199) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 381178 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 381178 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]