SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001706 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001706 [ RunTime:0.001575s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (461376,123265,156321,1030657,106373,361129,600862,796571,438475,702771,308693,24261,356106,910071,496784,395593,886734,77846,442535,675858,504329,982494,63435,590687,894896,785434,707210,264798,828957,237800,241972,1012699,3016,97558,707729,467737,843008,566336,849037,34396,257158,438158,512188,32379,591046,464158,493648,481634,462741,950923,319884,388174,297630,83515,433252,571930,394750,910195,703087,497961) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000902s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001706 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001706 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]