SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1006136 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1006136 [ RunTime:0.002748s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (499920,187234,14821,958149,101945,589748,887665,493423,557100,910075,46300,356559,441650,831219,305974,799039,351352,800891,590408,743516,388354,846817,498914,517674,769912,303748,474129,769939,379024,300015,462315,475423,325981,80813,481943,416705,198697,918377,593364,953307,1036385,582966,190170,911093,283158,69092,645128,788905,277078,430952,76,500817,71466,1039795,823189,295641,202978,1028622,377447,98290) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1006136 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1006136 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]