SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503697 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503697 [ RunTime:0.005218s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (381373,411214,550952,794467,273355,1040696,549205,142950,420829,246815,366191,736669,93435,635821,796962,248768,151263,942718,410957,62022,372018,502398,832885,485898,737745,45259,353994,218530,607300,915710,157691,191176,938668,194766,706992,523117,467178,757312,710422,212366,340486,159723,562622,249760,634973,106002,610367,909791,823526,1025020,387185,651361,915175,891553,59370,952010,927097,628313,59747,940840) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003223s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503697 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503697 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000469s ]