SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 536097 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 536097 [ RunTime:0.004325s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (247154,1037070,353764,869314,988791,734386,286030,821260,28064,517495,396427,809850,463294,712718,550112,451881,180922,762690,5282,567864,717782,816255,1015949,318093,570149,858003,97014,95878,448801,858674,224318,154799,180543,944906,357864,326922,391053,17541,11914,93208,853355,433167,725774,282015,521737,686447,420693,625761,673184,696859,321171,567817,873065,263202,558372,424121,630263,229900,187381,905261) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001467s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 536097 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 536097 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000691s ]