SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001304s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1003026 LIMIT 1 [ RunTime:0.001291s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1003026 [ RunTime:0.001356s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (474015,415581,172660,90615,342621,759334,863067,533955,452007,504215,162267,9178,1041938,753322,705686,836031,696974,596704,596659,642098,160582,229015,146996,861378,300594,716161,106386,99354,880366,911354,486858,207278,538810,84379,854575,550851,986604,985075,972019,828518,971711,484565,733029,844428,609575,578574,506816,500050,693083,264210,1021500,391882,338180,475629,762059,48514,157119,324167,787059,398367) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.010348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1003026 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1003026 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]