SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003408s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 565801 LIMIT 1 [ RunTime:0.002950s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 565801 [ RunTime:0.003827s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (4262,981520,305708,211978,790433,707014,391413,304117,934352,6514,827954,738633,668301,732451,1021567,852943,844938,553170,902002,851957,163602,378260,432712,723660,405383,923922,809019,405992,650205,945974,750171,783694,85919,51245,26059,920148,958456,935510,830679,322123,40407,701342,565657,625313,1004995,204072,741068,4764,166247,757041,680615,567311,548848,496667,532499,6999,969772,828135,447770,263894) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002239s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 565801 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 565801 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000513s ]