SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000924s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 914943 LIMIT 1 [ RunTime:0.000486s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 914943 [ RunTime:0.004371s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (978242,86200,526004,467822,668378,861997,935575,955266,429856,811572,924567,801018,871751,736103,114937,544217,648578,487457,30016,1001376,111365,826471,652854,516551,169224,796983,908645,61302,20848,838742,531419,16793,215383,427493,613910,637977,200998,496729,571313,934534,117982,757796,868602,1003590,1022996,512202,849708,716901,924450,838606,268615,1010938,184563,778589,800835,18709,660685,381614,697845,4685) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 914943 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 914943 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000445s ]