SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019553 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019553 [ RunTime:0.001654s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (518568,522087,185645,1040031,663199,696228,779359,109508,623517,3688,330106,43469,134716,662995,348178,71051,731159,368281,132538,848120,924198,487534,1044752,227616,815397,411718,388896,872823,1016637,1030169,103054,31683,260866,970468,853883,110783,556671,13822,1033260,707173,328057,433705,590521,440185,795691,28784,37439,616168,970405,848893,311078,322943,1045415,645067,298969,216945,794530,838907,248025,557020) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019553 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019553 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]